sqlplus / as sysdba

sqlplus hr@//localhost:1521/pdb1

@nazwa_skryptu.sql

@/home/oracle/scripts/nazwa_skryptu.sql

@?/rdbms/admin/utlrp.sql

sqlplus hr@//localhost:1521/pdb1

SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, PHONE_NUMBER, SALARY, HIRE_DATE FROM HR.EMPLOYEES;

SET LINESIZE 300
SET PAGESIZE 100

DESC HR.EMPLOYEES;

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';


COLUMN EMPLOYEE_ID FORMAT 9999
COLUMN FIRST_NAME FORMAT A8
COLUMN LAST_NAME FORMAT A12
COLUMN PHONE_NUMBER FORMAT A15
COLUMN SALARY FORMAT 99999.99

SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, PHONE_NUMBER, SALARY, HIRE_DATE FROM HR.EMPLOYEES;

EXIT

QUIT